Ì i 2
edit.log
[edit.date,edit.soc.sec,edit.guar,edit.number]
*(HP5)HPGED[pgED,pgS,pg,pgEN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
edit.date 8 DATE L pgED
edit.soc.sec 12 FREE L pgS
edit.guar 44 URN L PBR.GUAR pg
edit.number 2 PINT R pgEN
edit.item 15 CHOICE L *(HP5)HPGED[pgED,pgS,pg,pgEN]|0
edit.new.val 30 FREE L *(HP5)HPGED[pgED,pgS,pg,pgEN]|4
edit.old.val 30 FREE L *(HP5)HPGED[pgED,pgS,pg,pgEN]|3
edit.time 4 HHMM L *(HP5)HPGED[pgED,pgS,pg,pgEN]|1
edit.user 10 FREE L MIS.USER *(HP5)HPGED[pgED,pgS,pg,pgEN]|2
Ì € i 2
main
[guar]
*(HP5)HPG[pg]
Field Name Len Dat Typ J DPM Offset/Local/VAL
guar 44 URN L pg
addr1 30 FREE L *(HP5)HPG[pg]A|1
addr2 30 FREE L *(HP5)HPG[pg]A|2
bill.group 10 FREE L PBR.BILLING.GRP*(HP5)HPG[pg]|2
billed.balance 15 SMONEY R *(HP5)HPG[pg]T["C"]|0
birthdate 10 BDATE L *(HP5)HPG[pg]|4
city 20 FREE L *(HP5)HPG[pg]A|3
cntrct.date 8 DATE L *(HP5)HPG[pg]|16
cntrct.mnth.amt 10 SMONEY R *(HP5)HPG[pg]|15
dunning.msg 10 FREE L PBR.DUN.MSG *(HP5)HPG[pg]C|0
emp.addr1 30 FREE L *(HP5)HPG[pg]E|2
emp.addr2 30 FREE L *(HP5)HPG[pg]E|3
emp.city 20 FREE L *(HP5)HPG[pg]E|4
emp.name 30 FREE L *(HP5)HPG[pg]E|1
emp.occupation 20 FREE L *(HP5)HPG[pg]E|8
emp.phone 18 FREE L *(HP5)HPG[pg]E|7
emp.state 3 FREE L *(HP5)HPG[pg]E|5
emp.status 10 FREE L MIS.EMP.STATUS *(HP5)HPG[pg]E|9
emp.zip 10 ZIP.POST L *(HP5)HPG[pg]E|6
employer 10 FREE L PBR.EMPLOYER *(HP5)HPG[pg]E|0
first.bch.date 8 DATE L *(HP5)HPG[pg]|17
language 10 FREE L PBR.LANGUAGE *(HP5)HPG[pg]|7
last.pay.date 8 DATE L *(HP5)HPG[pg]|18
last.stmt.date 8 DATE L *(HP5)HPG[pg]|14
last.txn 5 URN L *(HP5)HPG[pg]|13
marital.status 10 FREE L MIS.MAR.STATUS *(HP5)HPG[pg]|6
name 30 NAME L *(HP5)HPG[pg]|0
open.date 8 DATE L *(HP5)HPG[pg]|9
open.time 4 HHMM L *(HP5)HPG[pg]|10
open.type 3 CHOICE L *(HP5)HPG[pg]|12
open.user 10 FREE L MIS.USER *(HP5)HPG[pg]|11
phone 18 FREE L *(HP5)HPG[pg]A|6
sex 1 CHOICE L *(HP5)HPG[pg]|5
soc.sec 13 FREE L *(HP5)HPG[pg]|1
sort.name 30 FREE L *(HP5)HPG[pg]|8
state 3 FREE L *(HP5)HPG[pg]A|4
stmt.msg.txt 50 FREE L *(HP5)HPG[pg]C|1
suppress.stmt 1 YN L *(HP5)HPG[pg]|3
zip 10 ZIP.POST L *(HP5)HPG[pg]A|5
Ì € i 2
txns.stmt
[guar, stmt.urn]
*(HP5)HPG[pg]T["B",ppgs]
Field Name Len Dat Typ J DPM Offset/Local/VAL
stmt.urn 5 URN L ppgs
stmt.age.0 8 SMONEY R *(HP5)HPG[pg]T["B",ppgs]|6
stmt.age.1 8 SMONEY R *(HP5)HPG[pg]T["B",ppgs]|7
stmt.age.2 8 SMONEY R *(HP5)HPG[pg]T["B",ppgs]|8
stmt.age.3 8 SMONEY R *(HP5)HPG[pg]T["B",ppgs]|9
stmt.age.4 8 SMONEY R *(HP5)HPG[pg]T["B",ppgs]|10
stmt.age.5 8 SMONEY R *(HP5)HPG[pg]T["B",ppgs]|11
stmt.age.6 8 SMONEY R *(HP5)HPG[pg]T["B",ppgs]|12
stmt.billed.amt 9 SMONEY R *(HP5)HPG[pg]T["B",ppgs]|3
stmt.date 8 DATE L *(HP5)HPG[pg]T["B",ppgs]|0
stmt.number 14 FREE L *(HP5)HPG[pg]T["B",ppgs]|18
stmt.open.item 1 YN L *(HP5)HPG[pg]T["B",ppgs]|15
stmt.pg.tot 3 INT R *(HP5)HPG[pg]T["B",ppgs]|17
stmt.post.trans.to.pt 1 YN L *(HP5)HPG[pg]T["B",ppgs]|16
stmt.print.date 8 DATE L *(HP5)HPG[pg]T["B",ppgs]|5
stmt.prior.bal 9 SMONEY R *(HP5)HPG[pg]T["B",ppgs]|2
stmt.pt.age.0 8 SMONEY R *(HP5)HPG[pg]T["B",ppgs]A|1
stmt.pt.age.1 8 SMONEY R *(HP5)HPG[pg]T["B",ppgs]A|2
stmt.pt.age.2 8 SMONEY R *(HP5)HPG[pg]T["B",ppgs]A|3
stmt.pt.age.3 8 SMONEY R *(HP5)HPG[pg]T["B",ppgs]A|4
stmt.pt.age.4 8 SMONEY R *(HP5)HPG[pg]T["B",ppgs]A|5
stmt.pt.age.5 8 SMONEY R *(HP5)HPG[pg]T["B",ppgs]A|6
stmt.pt.age.6 8 SMONEY R *(HP5)HPG[pg]T["B",ppgs]A|7
stmt.pt.bill.grp.user 10 FREE L *(HP5)HPG[pg]T["B",ppgs]A|8
stmt.pt.sort.key1 84 FREE L *(HP5)HPG[pg]T["B",ppgs]A|9
stmt.pt.total 8 SMONEY R *(HP5)HPG[pg]T["B",ppgs]A|0
stmt.total 8 SMONEY R VAL=@stmt.prior.bal+@stmt.billed.amt
stmt.type 1 CHOICE L *(HP5)HPG[pg]T["B",ppgs]|13
stmt.user 10 FREE L MIS.USER *(HP5)HPG[pg]T["B",ppgs]|14
Ì € i 2
txns.stmt.distrib
[guar,stmt.urn, stmt.dis.seq]
*(HP5)HPG[pg]T["B",ppgs]T[ppfsD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
stmt.dis.seq 4 FREE L ppfsD
stmt.account 44 URN L PBR.ACT *(HP5)HPG[pg]T["B",ppgs]T[ppfsD]|0
stmt.acct.stmt 5 URN L *(HP5)HPG[pg]T["B",ppgs]T[ppfsD]|1
stmt.print.acct 1 YN L *(HP5)HPG[pg]T["B",ppgs]T[ppfsD]|2
Index Files Subscripts/Physical Base
acct.x [guar,account]
?(HP)HPGA[pg,pz]
bill.grp.x [bill.group,guar]
?(HP)HPGB[pdb,pg]
name.x [sort.name,guar]
?(HP)HPGN[pgN,pg]
phone.other.x [phone,guar]
?(HP)HPGPO[pgPH,pg]
phone.seven.x [phone,guar]
?(HP)HPGPS[pgPH,pg]
phone.ten.x [phone,guar]
?(HP)HPGPT[pgPH,pg]
soc.sec.x [soc.sec,guar]
?(HP)HPGR[pgS,pg]
stmt.number.x [stmt.number,guar,stmt.urn]
?(HP)HPGSN[pgsn,pg,ppgs]
|
|
| | |